package cn.gson.springboot.model.mapper.aftermapper;

import cn.gson.springboot.model.pjos.Complain;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface ComplainMapper {

    //分页查询投诉表
    public List<Complain> comPage(@Param("planUrgecy") Integer states,
                                  @Param("planSubject") String search);

    //根据投诉id查询投诉表
    public Complain planAll(@Param("planId") Integer planId);

    //投诉花费时间分布
    public List<Complain> planByDate();

    //投诉类型分布
    public List<Complain> planByClass();

    //投诉月度统计月份
    public List<String> dateByMonth();

    //投诉月度统计数
    public List<Integer> dateByCount();

    //客户投诉次数统计名称
    public List<String> customByName();

    //客户投诉次数月度统计数
    public List<Integer> customByCount();

}
